﻿CREATE TABLE [DailyPrayers].[PrayerTimes]
(
	PrayerID int NOT NULL IDENTITY(1,1),
	LocationID int NOT NULL,
	[Month] [tinyint] NOT NULL,
	[Day] [tinyint] NOT NULL,
	[IMonth] [tinyint] NOT NULL,
	[IDay] [tinyint] NOT NULL,
	[Fajr] [varchar](50) NULL,
	[FajrIqama] [varchar](50) NULL,
	[Sunrise] [varchar](50) NULL,
	[Duhr] [varchar](50) NULL,
	[DuhrIqama] [varchar](50) NULL,
	[Asr] [varchar](50) NULL,
	[AsrIqama] [varchar](50) NULL,
	[Maghrib] [varchar](50) NULL,
	[MaghribIqama] [varchar](50) NULL,
	[Isha] [varchar](50) NULL,
	[IshaIqama] [varchar](50) NULL
)
